package zzws.dbstructure;

/**
 * 列名的属性名称采用列所在表的表名缩写为前缀
 * */
public class ColumnName {
	
	
	/**
	 *	酬劳等级表WSRewardLevel
	 * */
	public static String 	WSRLJobRewardID		=	"JobRewardID";
	public static String	WSRLJobRewardPerHour	=	"JobRewardPerHour";
	
	/**
	 * 岗位类型表WSJobType
	 * */
	public static String	WSJTJobTypeID	=	"JobTypeID";
	public static String	WSJTJobTypeName	=	"JobTypeName";
	
	
	/**
	 * 单位信息表WSUnit
	 * */
	public static String	WSUUnitID		=	"UnitID";
	public static String	WSUUnitName		=	"UnitName";
	public static String	WSUUnitFormalStaffNum	=	"UnitFormalStaffNum";
	
	
	/**
	 * 管理员信息表ZZManager
	 * */
	public static String	ZZMID		=	"Id";
	public static String	ZZMManagerName	=	"ManagerName";
	public static String	ZZMManagerPassword	=	"ManagerPassword";
	public static String	ZZMManagerLevel	=	"ManagerLevel";
	public static String	ZZMCollegeID	=	"CollegeId";
	public static String	ZZMIsVerify		=	"IsVerify";
	public static String	ZZMIsDelete		=	"IsDelete";
	public static String	ZZMIsSuperModify	=	"IsSuperModify";
	public static String	ZZMLoadManage	=	"LoadManage";
	public static String	ZZMPoorStuManage	=	"PoorStuManage";
	public static String	ZZMAwardedManage	=	"AwardedManage";
	public static String	ZZMWorkStudyManage	=	"WorkStudyManage";

	/**
	 * 备用学生WSSpareStuInfo
	 * */
	public static String	WSSSISpareID	=	"SpareID";
	public static String	WSSSIStuNo	=	"StuNo";
	public static String	WSSSIIdleTeam	=	"IdleTeam";
	public static String	WSSSIIdleMonthes	=	"IdleMonthes";
	public static String	WSSSIIdlePeriod		=	"IdlePeriod";
	public static String	WSSSIActivation		=	"Activation";
	public static String	WSSSITempWorking	=	"TempWorking";
	
	/**
	 * 系统内消息表WSSysInnerInfo
	 * */
	public static String	WSSIIInfoID		=	"InfoID";
	public static String	WSSIIInfoTypeID	=	"InfoTypeID";
	public static String	WSSIIInfoSender	=	"InfoSender";
	public static String	WSSIIInfoGenerateTime	=	"InfoGenerateTime";
	public static String	WSSIIInfoTitle	=	"InfoTitle";
	public static String	WSSIIInfoContent	=	"InfoContent";
	public static String	WSSIIIsAppendix	=	"IsAppendix";
	public static String	WSSIIIsAllStu	=	"IsAllStu";
	public static String	WSSIIIsAllUnit	=	"IsAllUnit";
	public static String	WSSIIIndependOrGroup	=	"IndependOrGroup";
	public static String	WSSIIInfoStatus		=	"InfoStatus";
	
	/**
	 * 系统内消息类型表WSSysInnerInfoType
	 * */
	public static String	WSSIITInfoTypeID	=	"InfoTypeID";
	public static String	WSSIITInfoTypeName	=	"InfoTypeName";
	
	/**
	 * 系统内消息接受者表WSSysInfoSingleStuRec 级联WSSysInnerInfo
	 * */
	public static String	WSSISSRInfoID	=	"InfoID";
	public static String	WSSISSRReceiver	=	"Receiver";
	
	/**
	 * 系统内消息接受者表WSSysInfoSingleUnitRec 级联WSSysInnerInfo
	 * */
	public static String	WSSISURInfoID	=	"InfoID";
	public static String	WSSISURReceiver	=	"Receiver";

	/**
	 * 系统内消息接受者表WSSysInfoGroupStusRec 级联WSSysInnerInfo
	 * */
	public static String	WSSIGSRInfoID 	=	"InfoID";
	public static String	WSSIGSRJobID	=	"JobID";
	public static String	WSSIGSRJobName	=	"JobName";
	public static String	WSSIGSRStatus	=	"Status";
	
	/**
	 * 系统内消息附件表WSSysInnerInfoAppendix 级联WSSysInnerInfo
	 * */
	public static String 	WSSIIAAppendixID	=	"AppendixID";
	public static String	WSSIIAInfoID	=	"InfoID";
	public static String	WSSIIAAppendixName	=	"AppendixName";
	public static String	WSSIIAAppendixSaveName	=	"AppendixSaveName";
	public static String	WSSIIAAppendixSavePath	=	"AppendixSavePath";
	public static String	WSSIIADownLoadCount		=	"DownLoadCount";
	
	/**
	 * 文档下载表WSDocumentDownload
	 * */
	public static String	WSDDDocumentID	=	"DocumentID";
	public static String	WSDDUploadTime	=	"UploadTime";
	public static String	WSDDDocumentName	=	"DocumentName";
	public static String	WSDDDocumentSaveName	=	"DocumentSaveName";
	public static String	WSDDDocumentSavePath	=	"DocumentSavePath";
	public static String	WSDDDownloadCount	=	"DownloadCount";
	
	/**
	 * 校内勤工助学批次管理WSWorkStudyBatch
	 * */
	public static String	WSWSBWSBatchID	=	"WSBatchID";
	public static String	WSWSBWSBatchName	=	"WSBatchName";
	public static String	WSWSBJobSetEndTime	=	"JobSetEndTime";
	public static String	WSWSBStuApplyStartTime	=	"StuApplyStartTime";
	public static String	WSWSBStuApplyEndTime	=	"StuApplyEndTime";
	public static String	WSWSBWSBatchStatus	=	"WSBatchStatus";
	
	/**
	 * 固定岗位信息表WSRegularJob
	 * */
	public static String	WSRJJobID	=	"JobID";
	public static String	WSRJJobName	=	"JobName";
	public static String	WSRJWSBatchID	=	"WSBatchID";
	public static String	WSRJUnitID	=	"UnitID";
	public static String	WSRJJobTypeID	=	"JobTypeID";
	public static String	WSRJHaveInterview	=	"Interview";
	public static String	WSRJNumOfRecruit	=	"NumOfRecruit";
	public static String	WSRJDiffBoyGirl		=	"DiffBoyGirl";
	public static String	WSRJNumOfBoy		=	"NumOfBoy";
	public static String	WSRJNumOfGirl		=	"NumOfGirl";
	public static String	WSRJJobContent		=	"JobContent";
	public static String	WSRJJobMonthes		=	"JobMonthes";
	public static String	WSRJJobPeriod		=	"JobPeriod";
	public static String	WSRJJobLocation		=	"JobLocation";
	public static String	WSRJJobRewardID		=	"JobRewardID";
	public static String	WSRJJobSubmitTime	=	"JobSubmitTime";
	public static String	WSRJJobPhone	=	"JobPhone";
	public static String	WSRJJobEmail	=	"JobEmail";
	public static String	WSRJJobStatus	=	"JobStatus";
	public static String	WSRJJobFailReason	=	"JobFailReason";
	
	
	/**
	 * 临时岗位信息表WSTempJob
	 * */
	public static String	WSTJJobID	=	"JobID";
	public static String	WSTJJobName	=	"JobName";
	public static String	WSTJWSBatchID	=	"WSBatchID";
	public static String	WSTJJobUnit		=	"JobUnit";
	public static String	WSTJJobTypeID	=	"JobTypeID";
	public static String	WSTJNumOfRecruit	=	"NumOfRecruit";
	public static String	WSTJJobContent	=	"JobContent";
	public static String	WSTJJobStartDay	=	"JobStartDay";
	public static String	WSTJJobEndDay	=	"JobEndDay";
	public static String	WSTJJobWorkPeriod	=	"JobWorkPeriod";
	public static String	WSTJJobLocation	=	"JobLoaction";
	public static String	WSTJJobRewardID	=	"JobRewardID";
	public static String	WSTJJobApplyTime	=	"JobApplyTime";
	public static String	WSTJJobPhone	=	"JobPhone";
	public static String	WSTJJobEmail	=	"JobEmail";
	public static String	WSTJJobStatus	=	"JobStatus";
	public static String	WSTJJobFailReason	=	"JobFailReason";

	/**
	 * 学生岗位申请单信息表WSStuJobsAppForm
	 * */
	public static String	WSSJAFJobsAppFormID		=	"JobsAppFormID";
	public static String	WSSJAFWSBatchID			=	"WSBatchID";
	public static String	WSSJAFStuNo		=	"StuNo";
	public static String	WSSJAFPermiAdjust	=	"PermitAdjust";
	public static String	WSSJAFJobsApplyTime	=	"JobsApplyTime";
	public static String	WSSJAFJobsID	=	"JobsID";
	public static String	WSSJAFApplyStatus	=	"ApplyStatus";
	public static String	WSSJAFRecmdJobID	=	"RecmdJobID";
	public static String	WSSJAFRecmdPri		=	"RecmdPri";
	public static String	WSSJAFRefusalTimes	=	"RefusalTimes";
	
	/**
	 * 临时岗位用工名单WSTempJobWorkStus
	 * */
	public static String	WSTJWSJobID		=	"JobID";
	public static String	WSTJWSStuNo		=	"StuNo";
	
	/**
	 * 合同单WSAgreemen
	 * */
	public static String	WSAAgreementID	=	"AgreementID";
	public static String	WSAJobID	=	"JobID";
	public static String	WSAStuNo	=	"StuNo";
	public static String	WSAWorkHoursPerMonth	=	"WorkHoursPerMonth";
	public static String	WSARewardPerMonth	=	"RewardPerMonth";
	
	/**
	 * 考勤单WSExamineList
	 * */
	public static String	WSELExamineID	=	"ExamineID";
	public static String	WSELUnitID	=	"UnitID";
	public static String	WSELExamineMonth	=	"ExamineMonth";
	public static String	WSELApplyTime	=	"ApplyTime";
	public static String	WSELStatus	=	"Status";
	
	/**
	 * 学生酬劳记录WSStuRewardRecord
	 * */
	public static String	WSSRRExamineID	=	"ExamineID";
	public static String	WSSRRStuNo		=	"StuNo";
	public static String	WSSRRJobID		=	"JobID";
	public static String	WSSRRJobName	=	"JobName";
	public static String	WSSRRIsRegular	=	"IsRegular";
	public static String	WSSRRJobTypeID	=	"JobTypeID";
	public static String	WSSRRJobRewardID	=	"JobRewardID";
	public static String	WSSRRCardNum	=	"CardNum";
	public static String	WSSRRWorkHoursPerMonth	=	"WorkHoursPerMonth";
	public static String	WSSRRRewardPerMonth	=	"RewardPerMonth";
	
	/**
	 * 学生基础信息字段  ZZBaseDate
	 * */
	public static String	ZZBDID	=	"ID";
	public static String	ZZBDStuNo	=	"StuNo";
	public static String	ZZBDStuName	=	"StuName";
	public static String	ZZBDPassword	=	"Password";
	public static String	ZZBDStuSex	=	"StuSex";
	public static String	ZZBDStuIDCard	=	"StuIDCard";
	public static String	ZZBDStuBirthday	=	"StuBirthday";
	public static String	ZZBDUnivercity	=	"Univercity";
	public static String	ZZBDGrade	=	"Grade";
	public static String	ZZBDHostalPhone	=	"HostalPhone";
	public static String	ZZBDNationId	=	"NationId";
	public static String	ZZBDNationName	=	"NationName";
	public static String	ZZBDStuPhone	=	"StuPhone";
	public static String	ZZBDStuEmail	=	"StuEmail";
	public static String	ZZBDStuJoinTime	=	"StuJoinTime";
	public static String	ZZBDCollegeId	=	"CollegeId";
	public static String	ZZBDCollegeName	=	"CollegeName";
	public static String	ZZBDSpecialId	=	"SepcialId";
	public static String	ZZBDSpecialName	=	"SepcialName";
	public static String	ZZBDStuXzId		=	"StuXzId";
	public static String	ZZBDStuXzName	=	"StuXzName";
	public static String	ZZBDStuXlId		=	"StuXlId";
	public static String	ZZBDStuXlName	=	"StuXlName";
	public static String	ZZBDFatherName	=	"FatherName";
	public static String	ZZBDFatherUnit	=	"FatherUnit";
	public static String	ZZBDFatherPhone	=	"FatherPhone";
	public static String	ZZBDMontherName	=	"MontherName";
	public static String	ZZBDMontherUnit	=	"MontherUnit";
	public static String	ZZBDMontherPhone	=	"MontherPhone";
	public static String	ZZBDFamilyAddress	=	"FamilyAddress";
	public static String	ZZBDPostalCode	=	"PostalCode";
	
	/**
	 * 困难生信息字段  ZZPoorStuInfo
	 * */
	public static String	ZZPSIID	=	"ID";
	public static String	ZZPSIStuNo	=	"StuNo";
	public static String	ZZPSIEndStudyTime	=	"EndStudyTime";
	public static String	ZZPSIFamilyPeopleSum	=	"FamilyPeopleSum";
	public static String	ZZPSIFamilyYearEarning	=	"FamilyYearEarning";
	public static String	ZZPSIPersonMonthAvgEarning	=	"PersonMonthAvgEarning";
	public static String	ZZPSICityOrVillage	=	"CityOrVillage";
	public static String	ZZPSIPoliticalBackground	=	"PliticalBackground";
	public static String	ZZPSIUnivercityEntrance	=	"UnivercityEntrance";
	public static String	ZZPSINowLivePlace	=	"NowLivePlace";
	public static String	ZZPSIPhone	=	"Phone";
	public static String	ZZPSIIsJoinPartWork		=	"IsJoinPartWork";
	public static String	ZZPSIFatherIdCard	=	"FatherIdCard";
	public static String	ZZPSIFatherLivePlace	=	"FatherLivePlace";
	public static String	ZZPSIFPostalCode	=	"FPostalCode";
	public static String	ZZPSIFVocation	=	"FVocation";
	public static String	ZZPSIFUnit	=	"FUnit";
	public static String	ZZPSIFUnitPhone	=	"FUnitPhone";
	public static String	ZZPSIMontherIdCard	=	"MontherIdCard";
	public static String	ZZPSIMontherLivePlace	=	"MontherLivePlace";
	public static String	ZZPSIMPostalCode	=	"MPostalCode";
	public static String	ZZPSIMVocation	=	"MVocation";
	public static String	ZZPSIMUnit	=	"MUnit";
	public static String	ZZPSIMUnitPhone	=	"MUnitPhone";
	public static String	ZZPSIApplyReason	=	"ApplyReason";
	public static String	ZZPSIStuBankNum	=	"StuBankNum";
	public static String	ZZPSIFamilyPhone	=	"FamilyPhone";
	public static String	ZZPSIPoorLevel	=	"PoorLevel";
	public static String	ZZPSIStatus	=	"Status";
	public static String	ZZPSICollegeManagerId	=	"CollegeManagerId";
	public static String	ZZPSIUnivercityManagerId	=	"UnivercityManagerId";
	public static String	ZZPSIBatchId	=	"BatchId";
	
	/**
	 * 贷款生信息字段  ZZStuLoan
	 * */
	public static String	ZZSLID	=	"ID";
	public static String	ZZSLStuNo	=	"StuNo";
	public static String	ZZSLFatherIdCard	=	"FatherIdCard";
	public static String	ZZSLMontherIdCard	=	"MontherIdCard";
	public static String	ZZSLFamilyAvgEarning	=	"FamilyAvgEarning";
	public static String	ZZSLFamilyPhone		=	"FamilyPhone";
	public static String	ZZSLLoanTotalSum	=	"LoanTotalSum";
	public static String	ZZSLLoanStudySum	=	"LoanStudySum";
	public static String	ZZSLLoanStaySum		=	"LoanStaySum";
	public static String	ZZSLLoanLiveSum		=	"LoanLiveSum";
	public static String	ZZSLLoanMonths		=	"LoanMonths";
	public static String	ZZSLLoanTimeBegin	=	"LoanTimeBegin";
	public static String	ZZSLLoanTimeEnd		=	"LoanTimeEnd";
	public static String	ZZSLLoanContractNo	=	"LoanContractNo";
	public static String	ZZSLFamilyTotalEarning	=	"FamilyTotalEarning";
	public static String	ZZSLNumOfPeopleInFamily	=	"NumOfPeopleInFamily";
	public static String	ZZSLStuLeaveTime	=	"StuLeaveTime";
	public static String	ZZSLStatus	=	"Status";
	public static String	ZZSLCollegeManagerId	=	"CollegeManagerId";
	public static String	ZZSLUnivercityManagerId	=	"UnivercityManagerId";
	public static String	ZZSLBatchId		=	"BatchId";
	
	/**
	 * 贷款和困难生审核状态  ZZStatus
	 * */
	public static String	ZZSDM	=	"DM";
	public static String	ZZSMC	=	"MC";
	
	/**
	 * 贷款批次信息  ZZBatch
	 * */
	public static String	ZZBID	=	"ID";
	public static String	ZZBBatchName	=	"BatchName";
	public static String	ZZBBStartTime	=	"BStartTime";
	public static String	ZZBBEndTime		=	"BEndTime";
	public static String	ZZBStatus		=	"BStatu";
	
	/**
	 * 贷款批次状态定义信息  ZZBatchStatus
	 * */
	public static String	ZZBSBatchStatusId	=	"BatchStatusId";
	public static String	ZZBSBatchStatusName	=	"BatchStatusName";
	
	/**
	 * 困难生批次信息  ZZPoorBatch
	 * */
	public static String	ZZPBID	=	"ID";
	public static String	ZZPBBatchName	=	"BatchName";
	public static String	ZZPBBStartTime	=	"BStartTime";
	public static String	ZZPBBEndTime	=	"BEndTime";
	public static String	ZZPBBStatu		=	"BStatu";
	
	/**
	 * 困难生批次状态定义信息  ZZPoorBatchStatus
	 * */
	public static String	ZZPBSBatchStatusId	=	"BatchStatusId";
	public static String	ZZPBSBatchStatusName	=	"BatchStatusName";
	
	/**
	 * 资助设置信息  ZZAward（不成熟）
	 * */
	public static String	ZZAAwardID	=	"AwardID";
	public static String	ZZAAwardName	=	"AwardName";
	public static String	ZZAAwardSum		=	"AwardSum";
	public static String	ZZAAwardRange	=	"AwardRange";
	public static String	ZZAInUse	=	"InUse";
	public static String	ZZAAwardCategoryID	=	"AwardCategoryID";
	
	/**
	 * 学生所获资助信息  ZZStuAward（不成熟）
	 * */
	public static String	ZZSAID	=	"ID";
	public static String	ZZSAStuNo	=	"StuNo";
	public static String	ZZSAAwardID	=	"AwardID";
	public static String	ZZSAAwardSum	=	"AwardSum";
	public static String	ZZSAAwardTime	=	"AwardTime";
	public static String	ZZSAAwardNum	=	"AwardNum";
	
	/**
	 * 资助分类信息  ZZAwardCategory（不成熟）
	 * */
	public static String	ZZACAwardCategoryID	=	"AwardCategoryID";
	public static String	ZZACAwardCategoryName	=	"AwardCategoryName";
	
	/**
	 * 管理员等级信息  ZZManagerLevel
	 * */
	public static String	ZZMLDM	=	"DM";
	public static String	ZZMLMC	=	"MC";
}



























